dataSource {
      pooled = false
      driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
      username = "sa"
      password = "123456"
      def dialect=org.hibernate.dialect.SQLServerDialect.class;
   }
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
	hibernate.show_sql = true
	connection.autocommit = false
}
// environment specific settings
environments {
    development {		
        dataSource {
          dbCreate = "create"
         url = "jdbc:sqlserver://localhost:1433;DatabaseName=SIMAT"
        }
    }
    test {
        dataSource {
            dbCreate = "create-drop"
            url = "jdbc:sqlserver://localhost:1433;DatabaseName=SIMAT"
        }
    }
    production {
        dataSource {
            dbCreate = "create-drop"
            url = "jdbc:sqlserver://localhost:1433;DatabaseName=SIMAT"
        }
    }
}
